import pandas as pd
import os

data_list = []
for fname in os.listdir('.'):
    if fname.endswith('.xlsx'):
        data_list.append(pd.read_excel(fname))

df = pd.concat(data_list)
df.to_excel('xx_merged.xlsx', index=False)

print('合并完成')
